package com.qb.ems.entity;

import javax.persistence.*;
import java.sql.Blob;
import java.sql.Clob;
import java.sql.Time;
import java.util.Date;

@Entity
@Table(
//        name="\"b_useR\"",
        name="b_user",
        indexes = {
        @Index(name = "idx_user_time", columnList = "time,name")

        }
//        ,catalog = "testsp520_2"
//        ,schema = "testsp"
       // ,uniqueConstraints={@UniqueConstraint(name="uni_user_name" ,columnNames = "name")}
)

public class User {

    @Id
//    @GeneratedValue(strategy= GenerationType.IDENTITY)
    private int id2;
    @Column
    private int id;
    @Column(name="cardNum")
    private long cardNum;
    @Column
    private float score;
    @Column
    private double score2;
    @Column
    private Date time;
    @Column
    private Time time2;
    @Column(columnDefinition="char")
    private String name;
//    @Column(columnDefinition="lvarchar")
    @Column(columnDefinition="char",name="myPassword")
    private String password;
    @Column
    private String email;

    @Column
    private Clob clob2;
    @Column
    private Blob blob1;
    @Column
    private  boolean b;


    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public long getCardNum() {
        return cardNum;
    }

    public void setCardNum(long cardNum) {
        this.cardNum = cardNum;
    }

    public float getScore() {
        return score;
    }

    public void setScore(float score) {
        this.score = score;
    }

    public double getScore2() {
        return score2;
    }

    public int getId2() {
        return id2;
    }

    public void setId2(int id2) {
        this.id2 = id2;
    }

    public void setScore2(double score2) {
        this.score2 = score2;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }


    public Clob getClob2() {
        return clob2;
    }

    public void setClob2(Clob clob2) {
        this.clob2 = clob2;
    }

    public Blob getBlob1() {
        return blob1;
    }

    public void setBlob1(Blob blob1) {
        this.blob1 = blob1;
    }

    public boolean isB() {
        return b;
    }

    public void setB(boolean b) {
        this.b = b;
    }
    public Date getTime() {
        return time;
    }

    public void setTime(Date time) {
        this.time = time;
    }

    public Time getTime2() {
        return time2;
    }

    public void setTime2(Time time2) {
        this.time2 = time2;
    }
}